Skip to main content

DB2 Query

Activity Description​

Executes a query on a DB2 database and returns a table.

Output​

A ResultSet.

note

To use DB2 activities, you need to download the latest version of the Data Server Driver Package from the IBM website and install it on the machine where the Resolve Actions executor is installed.
After installing the Data Server Driver Package, contact your Resolve representative for updating the path to the package in the activity's configuration.

Settings​

  • Query – The query's text. For example, Select * from administrator.catalog.
  • Connection String – Specifies the required connection string in order to connect the database.
    Example: Server=192.168.1.10:50000;Database=SAMPLE;
  • User Authentication – Determines whether a user's authentication credentials are required to execute the query (if the credentials are not specified in the clear text connection string).
  • User name – A DB2 user authorized to execute the query (e.g., sa).
  • Password – The user's password.
note

To avoid translation of %TEXT.% (in case TEXT is not a variable name), add @ before the percentage character. For example: Select * From TableName Where ColumnName LIKE '@%TEXT%'

note

To use the word variable within a query, use the following convention: @%variable% (else it is referred to as a system variable).